Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ads
Starting Member
23 Posts |
 Posted - 2012-07-19 : 05:56:16
|
| Hi,I'm having trouble connecting to a database on another server. I have setup the DSN which in testing works perfect. However when running the asp script with the follwing code: <% Dim rsGetInvoiceContact Dim rsGetInvoiceContact_numRows Set rsGetInvoiceContact = Server.CreateObject("ADODB.Recordset") rsGetInvoiceContact.ActiveConnection = MM_conn_to_EFACs_STRING_ap rsGetInvoiceContact.Source = "SELECT * from "& ActinicPersons &" p WHERE p.[Contact ID] = " + Replace(rsGetInvoiceContact__vInvoiceID, "'", "''") + "" rsGetInvoiceContact.CursorType = 0 rsGetInvoiceContact.CursorLocation = 2 rsGetInvoiceContact.LockType = 1 rsGetInvoiceContact.Open() rsGetInvoiceContact_numRows = 0 %>With the below connection string: Dim MM_conn_to_EFACs_STRING_ap MM_conn_to_EFACs_STRING_ap = "dsn=DSNefacsdb2;uid=IUSR_RFS01;pwd=Splendid01;"The error show after running the script: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error. /Sales/order_entry.asp, line 55When running the script against the local database it works as I want it, I have adjusted all the permissions on the other database for the user IUSR_RFS01, but still no joy! :( |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-19 : 07:08:14
|
| Looks like the system doesn't like the sql you have sent it.Could be something doesn't exist, the sql is wrong or your connection doesn't have permission on the objects.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Database connection from one server to another