Search results for query: *

I'm am using DTS for importing multiple txt files from a certain directory (as described here: http://www.sqldts.com/?246) How could I also import for every record the name of the source file it comes from? The import is being done to a SQL server table where I will add a varchar column, let's...

What is MDAC?

First I connect adp to SQL under File > Connection etc..., and then I setup a system DSN using SQL Server driver. The system DSN setup is time consuming since this has to happen on each client machine individualy. Is that correct? Is the system data source needed to get an adp connect to SQL...

Because I don't know of any other mean to connect adp to SQL server. I would be glad to learn about other alternative(s), please.

I am setting up SQL Server ODBC connections on several machines on our network for "adp" front-end. But when I go to choose the server I want to connect to from the server drop down list, I got two or even three server names e.g.:"COMPANYSERV", "CompanyServ" and "CompanyServer". We have only...

I am setting up SQL Server ODBC connections on several machines on our network. But when I go to choose the server I want to connect to from the server drop down list, I got two or even three server names e.g.:"COMPANYSERV", "CompanyServ" and "CompanyServer". We have only one SQL server...

Thx for reply... How could I check if IP address of SQL Server can be accessed from outside?

Hi everyone, We want clients to connect via an Access Project front-end to a SQL Server database. SQL Server is located in our main office, and the clients will be located somewhere else, maybe outside the country. How do we connect the clients to the SQL database with adp front-end? SQL...

Thanks to both of you for the prompt respond. CajunCenturion, your numberically concatenation is not accurate since I may have in char3 "00000212355", so I will be missing the leading zeros. What I did is replaceing this: BigNum = CDec(char4) BigNum = CDec(BigNum) + (CDec(char3) *...

Hi, Following fields are in my db: [CodeBanque], char, 5 [CodeGuichet], char, 5 [NoCompte], char, 11 [CleRIB], char, 2 I need to concatenate those 4 fields and apply modulo 97 for Bank Account validation check. A msgbox must then appear with the result. (If = 0 it's OK. Else not.) The...

We lose regularly connection with SQL Server. (We connect on LAN via Access project front-end.) That happens a few times a day. It longs for about 5 minutes and then we can go on. The problem is not the LAN, since connecting attempts on server machine itself (via Enterprise Manager) also fail...