I am trying to compile a simple ODBC and C example on Windows XP SP2.
I have Cygwin_NT 5.1.
This is the code (obtained from
http://www.easysoft.com/developer/l...#dm_fns_drivers)
i am attempting to compile.
ODBCTest.c
Quote:
Hi,
Something strange has happened to my table. I used Enterprise Manager today to delete 3 columns. When I went to re-link the table using Access Linked Table Manager, it gave me an error. I then deleted the link to the table, and tried to Link it again using 'Get External Data---Link Tables'. I am getting an error (no surprise!):
" 'dbo.tblSpaceUse.PK_RoomID' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long".
When I go into Enterprise Manager to 'manage Indexes' on the table, it shows me that the existing index is in fact dbo.tblSpaceUse.PK_RoomID.
About a month ago, I had to rename the index, because it had been pointing to the wrong table. The SQL I used to rename it (in Query Analyzer) is:
EXEC sp_rename 'dbo.tblSpaceUse.PK_RoomID', 'tblSpaceUse.PK_RoomID', 'INDEX'
I have been using the table successfully since then, until today. I have not done anything with the index; the only change I attempted was to delete 3 columns (not related to the index). I do not think I have made any changes to the table since I renamed the index.
I tried to run the rename SQL again (a desperate attempt!) and get the error message:
Server: Msg 15248, Level 11, State 1, Procedure sp_rename, Line 192
Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong.
Any ideas on what went wrong and what I can do to fix it???
Thanks,
Lori
I'm trying to lookup a value in another table linking on a column of datatype DT_R8. The lookup transform is complaining that I can't link on that datatype. However, the documentation says that it should work. I'm using the April CTP. Is this fixed in a later version? Any suggestions?
View 6 Replies View RelatedI just installed Microsoft SQL Server Express SP2. I setup a linked server to an Oracle database using the followings commands:
EXEC sp_addlinkedserver 'Oracle_DEV', 'Oracle', 'MSDAORA', 'DEV'
EXEC sp_addlinkedsrvlogin 'Oracle_DEV ', false, NULL, 'oracledbuser', 'dbuserpassword'
When I try and query the linked database I get the following error message:
Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
I've been searching the web and have gotten a lot of hits on the error message but have yet to uncover anything specifically related to linked servers or anything closely related enough to help me resolve this problem. Any advice would be appreciated. Thanks.
i already find the answer
thanks
I'm writing my first web site using VS 2005 and with my login page I'm trying to link with my SQL database using the following setting in my web.config file
<appSettings> <add key="SQLDB" value="server=STEVE-LT; database=MasterDB; uid=sa pwd="/></appSettings>
Then in my Login.aspx file I use the following code to access the SQL database
Dim Sc As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("SQLDB"))Dim SqlCmd As SqlCommand = New SqlCommand("Select Password, Name from Login")SqlCmd.CommandType = CommandType.StoredProcedure
Sc.Open()SqlCmd.Connection = Sc
This raises the following error message
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Could someone please tell me where I am going wrong. Thanks
I need to have database access via an
application to both sql server 6.5 & 7
the 6.5 uses mixed mode security,
the 7.0 uses trusted. Using
sp_addlinkedsrvlogin I can get from a client to
the 7.0 server, but not to the 6.5.
Is this even possible?
Can anyone tell me how to link to a oracle user? DO I use a predefined DSN? Do I just specify the server and the user and password?
Your assistance is appreciated,
David
I can't seem to link a 6.5 database from 7.0 and there's nothing in help which seems to help. Is it a "SQL Server" or do you have to use the OLE DB Provider? If the latter, what's supposed to be in the Product, Data Source, Provider String and Catalog fields? What about security? I've tried everything I can think of and can't get it to work. I also get errors creating a new DTS package that says "Could ot create Component Categories Manager", and then "Error during creation of DTS Package". I installed the desktop version of 7 on an NT Workstation. Has anyone successfully linked a 6.5 server in this environment?
View 4 Replies View RelatedHow would you link an online application form done in php to an SQL 7 server?
View 1 Replies View Relatedthis is the query I need help with
select a.RecordID,a.RelocateID,a.WhenConfirmed,b.RequestI D,b.DocumentID,b.RequestWhen from RelocateeDTA a inner join
docRequests b on ({a.RecordID}=' + CONVERT(VARCHAR, a.RecordID)'= b.WhereClause)
because I am trying to link RelocateeDTA that has RecordID to docRequests that has the same piece of data in field WhereClause but is a varchar, and I am getting an error message (syntax error or access violation)
Could somebody help me please
Hello there, im new here and wanted some help, i would be very grateful to anyone that can help:
I am setting up a DSN for my website (www.t-f-l.com, it may make more sense if you visit the site) i need it so members can sign up to the site (for the exact problem, click 'sign up now' on the website
I have set up the DSN but it says i need to link it to the database tables via MS access, im not sure at all how to do this...please can someone help
please explain in real idiot language....as i am new to this
dear experts,
i have two tables, tblcustomer and tblform. in tblcustomer i have cutomerid PK and i have also a field that link these two tables customername. in tblforms i have formname. customername and formname are not PK and customername has a lot of null values.
my question is that i want to link these two tables in customerid not the name and also to get the forms used by this customer. the thing is that i have to write a join query.
any suggestion to do that?
thanks my friends
I am not a database manager, but I work with people that use databases for sales and customer service... so I am not too familiar with the code and lingo... please bear with me.
We use two databases - one is in SQL, and it is for pre-sales customer service... i.e. tracking notes, phone calls, emails, and opportunities.
The second database is in Progress, and it is for actual quotes, tracking time, labor, materials, cost, and revenue.
As of now, our sales people have to enter new customers in the SQL database, and then duplicate the information in the Progress database. It's very frustrating, because everything needs to be entered twice - name, address, phone, shipping info, etc. etc. etc... When we first started this - 10 years ago - we were told that it could all be linked.
So my question is - is it possible to link these databases together? When our sales people enter a new contact in CRM, I'd like it to be automatically entered into the Progress database. If they make a change to a phone number, I'd like that to be updated in the Progress database. Also the other way around - if a shipping address is changed in the Progress database, I'd like it updated automatically in the SQL database.
Please tell me this is possible - and easy!!! Thanks for any help you can provide at all.
Jon
Does Exchange 2000 and SQL 2000 have to be the same machine to use exoledb.dll?
I want to link to an Exchange server and gain access to a Public Folder Contact Object for use as a lookup table within an Access front end. Someone directed me to use the Exchange OLE DB Provider, but it does not exist on my SQL machine.
Any help is appreciated
Sorry If I have posted this in the wrong head,
I would like to Establish connectivity to a Oracle9i DB thro Linked Server, Can any of you guide me to suitable links...
Thanks
I would like to use MVJ's formula for creating a date table.
I would like to use it with our main ERP database. However, I am reluctant to make changes to it because I fear that at some point when we upgrade that software and it's database that the upgrade program will delete my table.
So, here is my question. Performance wise, does it matter whether I add the date table to our ERP database or if I create another database (on the same server) for the custom date table? Does linking between databases take substantially longer than linking within the same database?
I know it's possible to link tables between Access and SQL Server using ODBC....however can u use DAO to do this? If there's a way i would appreciate some help. Thanks in advance.
View 2 Replies View RelatedI link to a sql server for the first time.
I change my .provider and .connectionstring to ADO
And know in one of my forms i get a debug Error; Invalid table Name "tablename"
can someone help me with this.
Thanks eddied
We are considering to implement Microsoft CRM 3.0 in our (small) organization. But we already have some customer information in another system (Unit4). We want to duplicate this information to our new CRM-system. This data will be read-only in the CRM-application.
Both the applications are installed on different servers with their own SQL databases(server 2000 and server 2005)
How can we duplicate the customer information from the unit4-system to Microsoft CRM? Can we simply link those databases using ?ODBC? (I heard something about ODBC but don’t know what it really is.)
Could someone clearly explain me what we have to do to make a construction as described above. (you don't have to give me all details) Is this construction possible anyway?
Thanks!
I am have created a test table in enterprise manager v8 and linked this table to an access database. I am able to append to the table from access but cant delete or update.
Ive set the permission settings to allow the user to update and del so cant work out why this isnt working?
ANyone got any ideas?
Hi,
I have a default instance that is Server1 (2000) and a named instance Server12005 (2005)
How do I link theses servers together so that my 2005 database can query the 2000 database.
Cheers
Leon
Two SQL Servers1) "Test"Payroll DBTransaction Tablepr_SubmitTransaction in Payroll DB********************************************2) "Production"Payroll DBTransaction TablePr_SubmitTransaction in Payroll DBAccounts DBPr_VerifyAccounts (@AcctNumber)********************************************I want to use same pr_VeriftAccounts in both test and productionPr_SubmitTransaction stored procedure.The pr_SubmitTransaction in production works fine when I sayExec Payroll.dbo.pr_VerifyAccounts as it is on same server. (WORKSFINE)Exec [PRODUCTION].Payroll.dbo.pr_VerifyAccounts (DOES NOT WORK)Should I use sp_addlinkedServer ?? to do this ?. Please provide me somefeedback.I know I can acheive this by front end, but I was do it in one storedprocedure.
View 7 Replies View RelatedLittle puzzle this.I need to link from SQL2000 to Access to get to a table held within anAccess DB. Now you can link within Access to a SQL table, but can thisbe done the other way round ? It's the first time I've needed to dosomething like this.What I have is an application which was written (by me) with an Accessbackend (to run on a CD) and now it needs to run on SQL. However, Iwant to be able to swap over between backends so that I can choosewhere this runs from. I've done this with the sole exception of onetable. Previously most of the data was held in one MDB file and a linkto another (one local copy and one on CD). My queries use the link toquery both local and the CD copy data together.I can re-write things if I need to, but I was curious about there beinga way of doing this. What I want in effect is to query a view on SQL,but the data will be held in Access instead of on SQL.I suppose I can import as I need it as the data is purely read only. Idon't think this can be done, but wanted to check first. I can alwaysmove the remainder of the data over to SQL if needed. It's not a bigproblem, just something I'm curious about.Any pointers would be appreciated.Thanks in advanceRyanp.s. In case anyone wonders why I have taken this approach it isbecause we have a query tool and data that we send out to clients onCD. Some now want this web based, so I will publish the application ona Citrix server, and by changing a config file can swap within theapplication to point to SQL (by changing the ODBC settings). This way,I only need one copy of the application and can change backends as Ineed to.
View 2 Replies View RelatedAbout linking server
Hi,
I am using sqlserver2005, when i make linked server connection between sqlserver2005 and oracle10g . It shows an error like that " Particular table doesnot exist or user doesn't have permission to connect ti this table"and below this one message is shown which is " Message 7314, line16".But i am giving it a proper "username/password ". In this linked server i am using Oracle10g new provider "ODAC101040.exe". so, please elaborate my such problem and also gives me the solution of this problem.
Thanx
regards
gautam
Hello,
Could someone please tell me (step by step as I am new!) how to establish a link from reporting services to an access database?
Thnaks,
RC
hi,
I have 2 databases from which my data will be coming from. How can I join this 2 databases in reporting services?
cherriesh
I need to query both Oracle and SQL Server tables for reporting and processing, ....no updates, insert or deletes.
Is creating a linked server the only way? My company does not want me to see the entire database.
Can you just link tables? Like Access or Excel does?
Any articles or links would be appreciated.
Thanks,
Mike
I want to link a file in the table, and want to open in the particuler programme, but the basic problem is by executing the T-SQL command this file open. Like creating the Hyperlink because I want to implement this command in my ASP project page.
Is the procedure is helpful for inserting, linking or opening the file in appropriate programme?
We have reporting services on 1 server, while the data comes off of another which does not have rs and on sql server 2000. I was able to build the reports and deploy it. But the report wont render. The error message is shown below.
My question is will linking servers work and if anyone has done this could you pl provide an example?
Thanks in advance
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'sds1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Can someone help me with how I should set the relationship in my address tables and how they will affect the deleting of a client?
So, if I have:
tblClients ClientID
tblClientAddresses AddressID
tblClientAddressLinks AddressID, ClientID
Currently I have them set as a 1-M from tblClients to tblClientAddressLinks and a 1-M from tblClientAddresses to tblClientAddressLinks
If I try and delete a client and there address is shared wont this go very wrong?
So here is what happens when I try and delete a client:
The DELETE statement conflicted with the REFERENCE constraint "FK_tblClientAddressLinks_tblClients". The conflict occurred in database "DBSQL2", table "dbo.tblcLIENTAddressLinks", column 'clientID'.The statement has been terminated.
Here is what happens when I try and delete an address:
The DELETE statement conflicted with the REFERENCE constraint "FK_tblClientAddressLinks_tblClientAddresses". The conflict occurred in database "DBSQL2", table "dbo.tblClientAddressLinks", column 'Address_ID'.The statement has been terminated.
Hello everyone... I am having a problem with linking my database to my formview. Whenever I try to configure my datasource and go to the advance setting to check "Generate Insert,...." option, it is dim and I con not select it.. what is the reason for this?
please help
thanks
i have tried linking all my aspx scripts with ms access, they all worked,now i have switched on to ms sql7...iam not familier with the codes used for sql...my main problem is the data source syntax...in case of access i had given the file address along with extension...eg: C:DataNortwind.mdb...so what should i do in case of sql... i have also given my code below
sub Page_load(sender as object, E as eventargs)
dim objconnection As sqlconnection
dim objcommand as sqlCommand
dim objadapter as sqlDataAdapter
dim objdata As DataSet
dim strsearch as String
dim sqlquery as String
strsearch = tb1.text
if Len(trim(strSearch))>0 then
objConnection = new sqlconnection("Data Source=(localhost);")
sqlquery= "select * from mayank where (name"&strsearch.ToString()&")"
objcommand = new sqlcommand(sqlquery, objconnection)
objadapter = new sqlDataAdapter(objcommand)
objdata = new DataSet()
objadapter.Fill(objdata)
DataGrid1.DataSource = objdata
DataGrid1.DataBind()
objConnection.close
Else
tb1.text= "enter your search here"
end if
end sub